from app.extensions import db

class User(db.Model):
    __tablename__ = 'users'
    userid = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(64),nullable=False)
    age = db.Column(db.Integer)
    phone = db.Column(db.String(20))
    introduce = db.Column(db.Text)
    status = db.Column(
        db.Enum('active', 'disabled', name='status'),
        default='active',
        nullable=False,
        comment='状态：active---激活，disabled---失效'
    )